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