UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '5/OpiJZKCSIoDLHfuGQLezA1soGmj9JQRnTd5kYtWbI=' 
WHERE 
  key_id = '648c46f09bdc6f84f0a67543a976a7a220062684b080089a04cfb76fb4b7a32d' 
  AND (
    token = '5/OpiJZKCSIoDLHfuGQLezA1soGmj9JQRnTd5kYtWbI=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00027