UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pLGxWNbbnSuSONkuoQFey1K9boJoffUUw+fNRihjkTw='
WHERE
key_id = '38b837e799e4b66a5bf033deb459f47904adf23bad85ec74e84419bef719ea52'
AND (
token = 'pLGxWNbbnSuSONkuoQFey1K9boJoffUUw+fNRihjkTw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)