UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '/3nES481nMt5z8l5XKU4EB7Qj9/2Nr5aZ7DgXC0l0Q0=' 
WHERE 
  key_id = '7af180243f75a4d9be86a5809b6ec25e40368ac4cec0b4e0476c82ca9a457876' 
  AND (
    token = '/3nES481nMt5z8l5XKU4EB7Qj9/2Nr5aZ7DgXC0l0Q0=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00022