UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7NmlehXXqvlRAftbexEmwDjCN1J9pOHgFiHamWewEKw='
WHERE
key_id = 'e40dfd15fe7405292a638b670f68100e1533987dd6f87911d313b5e919dcfd70'
AND (
token = '7NmlehXXqvlRAftbexEmwDjCN1J9pOHgFiHamWewEKw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)