UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RnZzyjNR/OFcsdnEZRaoksLv5OVVH58rDmItS+ViURU='
WHERE
key_id = '47617b0c4bc8e87277594dae414f3b5441b1de7c0ae7c57d963b2a56d82a8f5d'
AND (
token = 'RnZzyjNR/OFcsdnEZRaoksLv5OVVH58rDmItS+ViURU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)