UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dY/6KebRHL5Q/byX1i89cbM15Gk7exVy6DZ0v0zmKAg='
WHERE
key_id = 'fd0fefd774087c7b582b64eb34030bcf76c39826f6b1a32b61785f3a6faa454f'
AND (
token = 'dY/6KebRHL5Q/byX1i89cbM15Gk7exVy6DZ0v0zmKAg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)