UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/us8gzXaNRHut572mnUXO4uF+sWRcuwkNDKJ/I97+VY='
WHERE
key_id = 'c9ddb18e1c153f8a0bfeb739139d0ee4a4ada2aa4fb5f05bff60c1ce2e6c7d5f'
AND (
token = '/us8gzXaNRHut572mnUXO4uF+sWRcuwkNDKJ/I97+VY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)