UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'eC9rx/vXq/aVJprumaVKbimg182GfjjII76E0Qadbv0='
WHERE
key_id = 'bcc27f05f30b91e19cdefd8fa8f0215e0a65e38d9ac4392dec9295d72d91bbe9'
AND (
token = 'eC9rx/vXq/aVJprumaVKbimg182GfjjII76E0Qadbv0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)