UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'GarhtkuP8D5dg7vA+6R70Ac4xgORatLqloMlNcAu114=' 
WHERE 
  key_id = '8b05757a7d7b055e7c04a94c94bcf779ce7af0799afbfa5b6385156198698a38' 
  AND (
    token = 'GarhtkuP8D5dg7vA+6R70Ac4xgORatLqloMlNcAu114=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00024