UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8gqNxXkYGLGSUU5D4wAt2EUVmYTmIgGkz8DgoFNrEh0='
WHERE
key_id = 'd78f4851bcf54807d3d39c9a32ebedad830e7a1b7979dff7f043940292ed0727'
AND (
token = '8gqNxXkYGLGSUU5D4wAt2EUVmYTmIgGkz8DgoFNrEh0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)