UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'k7RmEutJoAzWRel5aQj5J61GMNk0i/brRg4hUwaJUYE='
WHERE
key_id = 'be87caf363e795fdc4de206c3e1d980ba095735a51b0bf3ade7c8bb68f29745a'
AND (
token = 'k7RmEutJoAzWRel5aQj5J61GMNk0i/brRg4hUwaJUYE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)