UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/hv/B3pJcsmUr29yUAH69Mq+NJHVxyOkhUHorPdjZ88='
WHERE
key_id = 'b04c0edc8c3b2226ae37c740523dea77666fbe4559922364397ba401a9444f3f'
AND (
token = '/hv/B3pJcsmUr29yUAH69Mq+NJHVxyOkhUHorPdjZ88='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)