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