UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Dc9GyLJjLVy3i54xZZX8oaQhwaZQ2IU+uMlBcA2H98o='
WHERE
key_id = 'c340a7823a817a61ff94e8c33933a46209f0be8aafe597e646d4d3ea96e441cf'
AND (
token = 'Dc9GyLJjLVy3i54xZZX8oaQhwaZQ2IU+uMlBcA2H98o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)