UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'A4tmlvW1crI11RuYvpnSLsKt5IucmDgQtTbc22gESnc='
WHERE
key_id = '25a097c50a37bc7fcb0e81e67938f95a10884fa661b1a3313dd1bdf7f6de9ed1'
AND (
token = 'A4tmlvW1crI11RuYvpnSLsKt5IucmDgQtTbc22gESnc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)