UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6wP5FD7siL4DQMO8YrMH5njPEhuIM9T0jZhNR3hflv4='
WHERE
key_id = '2fe489d11417325579e2671fcdbd3aa27e6f30b445cd6e941548ec0d92fb318f'
AND (
token = '6wP5FD7siL4DQMO8YrMH5njPEhuIM9T0jZhNR3hflv4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)