UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'mq5J+0U91mcY2jHW9ytesJXSW2Njk3TuyivDlbRDFWg=' 
WHERE 
  key_id = '18bf6bb3a695c21b1138f97bb08ad21aba4556c4e9846fc6c6d757d526528a0f' 
  AND (
    token = 'mq5J+0U91mcY2jHW9ytesJXSW2Njk3TuyivDlbRDFWg=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00028