UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mMIZ+/kwKdfqf2Kmrohkpz/AciT7SVwVB456hOWaM38='
WHERE
key_id = '8ec7e710ae8856801d7a7689e2f860673117fe42614d0212468cc9851f52a13a'
AND (
token = 'mMIZ+/kwKdfqf2Kmrohkpz/AciT7SVwVB456hOWaM38='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)