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