UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3VJpTSUb3zCgA1Ho1vSGgijg0ChnwnlzYDs7djEgJ9c='
WHERE
key_id = '9c293dc3cd919b2a32992b6513821380e780bd5d6afe671983793133d309725e'
AND (
token = '3VJpTSUb3zCgA1Ho1vSGgijg0ChnwnlzYDs7djEgJ9c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)