UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZQdoThGBZ/JlREL93SNTWTgaTm0qAcSffNMFo/1W2r4='
WHERE
key_id = '0505f541d1170241cb27fdc94563e6a9fe8377b0472e8320eeb0d97f9a3c7a09'
AND (
token = 'ZQdoThGBZ/JlREL93SNTWTgaTm0qAcSffNMFo/1W2r4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)