UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0fg3V1xTnQL7jT6hHsAiMwEq3ww+YsjZ3/74IHuEcDw='
WHERE
key_id = 'bacadb21601c3dc06afc9c5c92425e575cbc2f1d596e853a4d0b146dae5cd224'
AND (
token = '0fg3V1xTnQL7jT6hHsAiMwEq3ww+YsjZ3/74IHuEcDw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)