UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UZ17VnY5ekTbz/J+QpkxMOQb3zBHyx6uKAsvY8LWEN0='
WHERE
key_id = 'f8dec8ee4b4e0a31502a93388dedc7575f252fbcf9596b0b0abaaba227b06ce8'
AND (
token = 'UZ17VnY5ekTbz/J+QpkxMOQb3zBHyx6uKAsvY8LWEN0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)