UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '5sjWYcvAIfmU+hnhaytU7sVDw/NELNegyBSQj+YpSyY=' 
WHERE 
  key_id = 'de7b5ad8e691ab3906a3a15686074c1a50c1d29a1fcab3c38549bb23adc6861e' 
  AND (
    token = '5sjWYcvAIfmU+hnhaytU7sVDw/NELNegyBSQj+YpSyY=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00020