UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'q1pu5vKQcC+ZgSP8Q9sx60xlLg07C9FGH1ryIHEHVbc='
WHERE
key_id = 'd12e65bddb122b5c49bce456cc2763e4c78127f5818210edd46d8d93b56f9e66'
AND (
token = 'q1pu5vKQcC+ZgSP8Q9sx60xlLg07C9FGH1ryIHEHVbc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)