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