UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'QWzC5bz7VoghIqAkVy3DnVWQ6LJSYOcGMb1jMEkxtm0=' 
WHERE 
  key_id = '271afbdedfd78c06d03f018aa6baaa3e65f552378fa350d5d41095b72b8f8cb8' 
  AND (
    token = 'QWzC5bz7VoghIqAkVy3DnVWQ6LJSYOcGMb1jMEkxtm0=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00044