UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6U6DHbhNWIIf9/SMjhFdx3AocZYWokY5J4FGe/SojSM='
WHERE
key_id = 'a296170b0c06b54f421d1824759b4b6487b18993645c06a108399b2870c50ac5'
AND (
token = '6U6DHbhNWIIf9/SMjhFdx3AocZYWokY5J4FGe/SojSM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)