UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dHgf0e7Gcp27yPXqOVYXlx4ywpxzptjyPj5R1DSsiKA='
WHERE
key_id = 'bbb7ca462e81d41a28de08981cd5376f5750eb7440518b7571dcc6f1905386fd'
AND (
token = 'dHgf0e7Gcp27yPXqOVYXlx4ywpxzptjyPj5R1DSsiKA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)